Create VCR and MCR YOY
Step 1: Create VCR and MCR YOY (choose a line clustered and column chart)
a. Shared axis = Occurred date/month and Day of Week, Column values = Violent Crime Rate and Major Crime Rate ( Make sure to remove periods), Line values = VCR YOY and MCR YOY, Tooltips = VCR YOY Change and MCR YOY Change
b. Select formatting, in general X position = 743, Y position = 76, Width =537, Height = 284
c. Legend, Color = black, font = Constantia, text size = 8
d. Xaxis, Color = black, text size = 9, font = Constantia, title off
e. Yaxis, Color = black, text size = 9, font = Constantia, title off, show secondary on, color = black, text size = 9, font = Constantia
f. Data colors, VCR YOY = custom (2878BD), MCR YOY = custom (FDC543), Violent Crime Rate = custom (1E5A8E), Major Crime Rate = custom (BD890F)
g. Data labels, Color = black, text size = 9, font = Constantia, customize series VCR, MCR off
h. Shapes, shade area
i. Title, VCR and MCR YOY, Color = black, background = light gray, alignment = center, text size = 12, font = Constantia
j. Border = dark gray
Check out how the US has done with Violent Crime over the past